File: /var/www/html/orbidirectory.com/app/Http/Controllers/VehiclesController.php
<?php
namespace App\Http\Controllers;
use App\Models\CitySelection;
use App\Models\Transporter;
use App\Models\User;
use App\Models\VehicleMake;
use App\Models\VehicleModel;
use App\Models\Vehicles;
use App\Models\VehicleTypes;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Validator;
use Yajra\DataTables\Facades\DataTables;
class VehiclesController extends Controller
{
public function index(Request $request)
{
if ($request->ajax()) {
// $search_keyword = $request->get('search')['value'] ?? '';
// avoid zero column as it's checkbox so we can't sort by it
if ($request->has('order') && $request->order[0]['column'] != 0) {
$sort_column_number = $request->order[0]['column'];
$sort_column_dir = $request->order[0]['dir'];
$sort_column_key = $request->columns[$sort_column_number]['data'];
}
$main_query = Vehicles::query();
$query = $main_query;
if (!empty($sort_column_key)) {
$query = $query->orderBy($sort_column_key, $sort_column_dir);
} else {
$query = $query->orderByDesc('created_at');
}
// if (!empty($search_keyword)) {
// $query = $query->where(function ($q) use ($search_keyword) {
// $q->where('description', 'LIKE', '%' . $search_keyword . '%')
// ->orWhereHas('transporters.get_user', function ($q2) use ($search_keyword) {
// $q2->where('name', 'LIKE', '%' . $search_keyword . '%');
// })
// ->orWhereHas('get_make', function ($q2) use ($search_keyword) {
// $q2->where('name', 'LIKE', '%' . $search_keyword . '%');
// })
// ->orWhereHas('get_model', function ($q3) use ($search_keyword) {
// $q3->where('name', 'LIKE', '%' . $search_keyword . '%');
// })
// ->orWhereHas('Vehicle_type', function ($q4) use ($search_keyword) {
// $q4->where('name', 'LIKE', '%' . $search_keyword . '%');
// })
// ->orWhere('transmission_type', 'LIKE', '%' . $search_keyword . '%')
// ->orWhere('seating_capacity', 'LIKE', '%' . $search_keyword . '%')
// ->orWhere('service_type', 'LIKE', '%' . $search_keyword . '%');
// });
// $count_filter = $query->count();
// } else {
// $count_filter = $main_query->count();
// }
// $data = Vehicles::with('get_transporters')->get();
$data = $query->with('transporters','transporters.get_user', 'get_make', 'get_model', 'Vehicle_type');
$count_total = $main_query->count();
return DataTables::of($data)
->filter(function ($q) use ($request) {
if ($search = $request->input('search.value')) {
$q->where(function ($query) use ($search) {
$query->where('transmission_type', 'LIKE', "%{$search}%")
->orWhere('seating_capacity', 'LIKE', "%{$search}%")
->orWhere('service_type', 'LIKE', "%{$search}%")
->orWhereHas('transporters.get_user', function ($q) use ($search) {
$q->where('name', 'LIKE', "%{$search}%");
})
->orWhereHas('get_make', function ($q) use ($search) {
$q->where('name', 'LIKE', "%{$search}%");
})
->orWhereHas('get_model', function ($q) use ($search) {
$q->where('name', 'LIKE', "%{$search}%");
})
->orWhereHas('Vehicle_type', function ($q) use ($search) {
$q->where('name', 'LIKE', "%{$search}%");
});
});
}
})
->addColumn('transporter_name', function ($row) {
return $row->transporters && $row->transporters->get_user
? ucfirst($row->transporters->get_user->name)
: '';
})
->addColumn('make_id', function ($row) {
return $row->get_make ? $row->get_make->name : '';
})
->addColumn('model_id', function ($row) {
return $row->get_model ? $row->get_model->name : '';
})
->addColumn('vehicle_type_id', function ($row) {
return $row->Vehicle_type ? $row->Vehicle_type->name : '';
})
->addColumn('transmission_type', function ($row) {
return $row->transmission_type;
})
->addColumn('seating_capacity', function ($row) {
return $row->seating_capacity;
})
->addColumn('service_type', function ($row) {
return $row->service_type;
})
->editColumn('status', function ($row) {
if ($row->status == Vehicles::STATUS_ACTIVE) {
$status = 'Active';
$badgeClass = 'badge bg-success';
} elseif ($row->status == Vehicles::STATUS_INACTIVE) {
$status = 'Inactive';
$badgeClass = 'badge bg-warning';
} elseif ($row->status == Vehicles::STATUS_BANNED) {
$status = 'Banned';
$badgeClass = 'badge bg-danger';
} else {
$status = 'Unknown';
$badgeClass = 'badge bg-secondary';
}
return "<span class='status-label {$badgeClass}'>{$status}</span>";
})
->addColumn('action', function ($row) {
if ($row->is_admin !== 1) {
return view('admin.vehicles.partially.delete', compact('row'));
}
})
->rawColumns(['action','status'])
->with([
"recordsTotal" => $count_total,
// "recordsFiltered" => $count_filter,
])
->make(true);
}
return view('admin.vehicles.index');
}
public function create()
{
// $transporters = User::where('type', 2)->get();
$transporters = Transporter::all();
$vehicle_makes = VehicleMake::all();
$vehicle_models = VehicleModel::get();
// dd($vehicle_models);
$vehicle_types = VehicleTypes::all();
$cities = CitySelection::get();
return view('admin.vehicles.create', compact('transporters', 'vehicle_makes', 'vehicle_models', 'vehicle_types','cities'));
}
public function store(Request $request)
{
// dd($request->all());
$validator = Validator::make($request->all(), [
'transporter_id' => 'required|exists:transporters,id',
'vehicle_image' => 'required|image|mimes:jpeg,png,jpg,gif,svg|max:2048',
'make_id' => 'required|exists:vehicle_makes,id',
'model_id' => 'required|exists:vehicle_models,id',
'vehicle_type_id' => 'required|exists:vehicle_types,id',
'model_year' => 'required|integer|min:1900|max:' . date('Y'),
'seating_capacity' => 'required',
'license_plate' => 'required',
'description' => 'required|string',
// 'license_plate' => ['required', 'regex:/^[A-Z]{2}[0-9]{2}[A-Z]{1,2}[0-9]{4}$/i'],
'is_verified' => 'boolean',
'inactive_reason' => 'nullable|string',
]);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput();
}
$vehicle = new Vehicles();
$vehicle->transporter_id = $request->transporter_id;
$vehicle->make_id = $request->make_id;
$vehicle->model_id = $request->model_id;
$vehicle->vehicle_type_id = $request->vehicle_type_id;
$vehicle->model_year = $request->model_year;
$vehicle->fuel_type = $request->fuel_type;
$vehicle->transmission_type = $request->transmission_type;
$vehicle->service_type = $request->service_type;
$vehicle->seating_capacity = $request->seating_capacity;
$vehicle->license_plate = $request->license_plate;
$vehicle->description = $request->description;
$vehicle->is_verified = $request->is_verified;
$vehicle->license_plate = $request->license_plate;
$vehicle->status = $request->status;
// $vehicle->city_id = $request->city_id;
$vehicle->save();
if ($request->hasFile('vehicle_image')) {
$file = $request->file('vehicle_image');
try {
$media = $vehicle->addMedia($file)
->usingFileName(time() . '_' . $file->getClientOriginalName())
->toMediaCollection('vehicle_image');
} catch (\Exception $e) {
Log::error('File upload error: ' . $e->getMessage());
return redirect()->back()->with('error', 'Failed to upload the Image.');
}
}
return redirect()->route('vehicle.index')->with('success', 'Vehicle added Successfully');
}
public function edit(string $id)
{
$vehicle = Vehicles::find($id);
$transporters = Transporter::all();
$vehicle_models = VehicleModel::all();
$vehicle_makes = VehicleMake::all();
$vehicle_types = VehicleTypes::all();
$cities = CitySelection::get();
$selectedMakeId = $vehicle->make_id;
$selectedModelId = $vehicle->model_id;
if (isset($vehicle)) {
return view('admin.vehicles.edit', compact('vehicle', 'transporters',
'vehicle_models', 'vehicle_makes', 'vehicle_types','cities','selectedMakeId','selectedModelId'));
} else {
return back()->with('error', 'Vehicle does not exist');
}
}
public function update(Request $request, string $id)
{
$validator = Validator::make($request->all(), [
'transporter_id' => 'required|exists:transporters,id',
'make_id' => 'required|exists:vehicle_makes,id',
'model_id' => 'required|exists:vehicle_models,id',
'vehicle_type_id' => 'required|exists:vehicle_types,id',
'model_year' => 'required|integer|min:1900|max:' . date('Y'),
'seating_capacity' => 'required',
// 'license_plate' => 'required',
'license_plate' => ['required', 'regex:/^[A-Z]{2}[0-9]{2}[A-Z]{1,2}[0-9]{4}$/i'],
'description' => 'required|string',
'is_verified' => 'boolean',
'inactive_reason' => 'nullable|string',
]);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput();
}
$vehicle = Vehicles::find($id);
if (isset($vehicle)) {
$vehicle->transporter_id = $request->transporter_id;
$vehicle->make_id = $request->make_id;
$vehicle->model_id = $request->model_id;
$vehicle->vehicle_type_id = $request->vehicle_type_id;
$vehicle->model_year = $request->model_year;
$vehicle->fuel_type = $request->fuel_type;
$vehicle->transmission_type = $request->transmission_type;
$vehicle->service_type = $request->service_type;
$vehicle->seating_capacity = $request->seating_capacity;
$vehicle->license_plate = $request->license_plate;
$vehicle->description = $request->description;
$vehicle->is_verified = $request->is_verified;
$vehicle->license_plate = $request->license_plate;
$vehicle->status = $request->status;
// $vehicle->city_id = $request->city_id;
$vehicle->save();
if ($request->hasFile('vehicle_image')) {
$file = $request->file('vehicle_image');
if (!$file->isValid()) {
return redirect()->back()->with('error', 'Invalid file upload.');
}
try {
if ($vehicle->hasMedia('vehicle_image')) {
$vehicle->clearMediaCollection('vehicle_image');
}
$vehicle->addMedia($file)
->usingFileName(time() . '_' . $file->getClientOriginalName())
->toMediaCollection('vehicle_image');
} catch (\Exception $e) {
// Log the error and redirect back with an error message
\Log::error('File upload error: ' . $e->getMessage());
return redirect()->back()->with('error', 'Failed to upload the Image.');
}
}
return redirect()->route('vehicle.index')->with('success', 'Vehicle has been updated successfully.');
} else {
return back()->with('error', 'Vehicle not found.');
}
}
public function destroy(string $id)
{
$vehicle = Vehicles::find($id);
if (isset($vehicle)) {
$vehicle->Delete();
return redirect()->back()->with('success', 'Vehicle has been deleted successfully.');
} else {
return back()->with('error', 'Vehicle not found.');
}
}
}